"surrogate key" meaning in English

See surrogate key in All languages combined, or Wiktionary

Noun

Forms: surrogate keys [plural]
Head templates: {{en-noun}} surrogate key (plural surrogate keys)
  1. (databases) A unique identifier for an entity or object, not derived from application data. Translations (Translations): сурога́тен ключ (surogáten ključ) [masculine] (Bulgarian)

Inflected forms

Alternative forms

{
  "forms": [
    {
      "form": "surrogate keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "surrogate key (plural surrogate keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        {
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Entries with translation boxes",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with entries",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Bulgarian translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [],
          "source": "w"
        }
      ],
      "examples": [
        {
          "bold_text_offsets": [
            [
              91,
              104
            ]
          ],
          "text": "We weren't sure which columns in the table would have unique values, so we used a separate surrogate key as the primary key.",
          "type": "example"
        }
      ],
      "glosses": [
        "A unique identifier for an entity or object, not derived from application data."
      ],
      "id": "en-surrogate_key-en-noun-V9tvPeTx",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "unique identifier",
          "unique identifier"
        ],
        [
          "entity",
          "entity"
        ],
        [
          "object",
          "object"
        ],
        [
          "application",
          "application"
        ],
        [
          "data",
          "data"
        ]
      ],
      "raw_glosses": [
        "(databases) A unique identifier for an entity or object, not derived from application data."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "translations": [
        {
          "code": "bg",
          "lang": "Bulgarian",
          "lang_code": "bg",
          "roman": "surogáten ključ",
          "sense": "Translations",
          "tags": [
            "masculine"
          ],
          "word": "сурога́тен ключ"
        }
      ]
    }
  ],
  "word": "surrogate key"
}
{
  "forms": [
    {
      "form": "surrogate keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "surrogate key (plural surrogate keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "English terms with usage examples",
        "Entries with translation boxes",
        "Pages with 1 entry",
        "Pages with entries",
        "Terms with Bulgarian translations",
        "Translation table header lacks gloss",
        "en:Databases"
      ],
      "examples": [
        {
          "bold_text_offsets": [
            [
              91,
              104
            ]
          ],
          "text": "We weren't sure which columns in the table would have unique values, so we used a separate surrogate key as the primary key.",
          "type": "example"
        }
      ],
      "glosses": [
        "A unique identifier for an entity or object, not derived from application data."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "unique identifier",
          "unique identifier"
        ],
        [
          "entity",
          "entity"
        ],
        [
          "object",
          "object"
        ],
        [
          "application",
          "application"
        ],
        [
          "data",
          "data"
        ]
      ],
      "raw_glosses": [
        "(databases) A unique identifier for an entity or object, not derived from application data."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "translations": [
    {
      "code": "bg",
      "lang": "Bulgarian",
      "lang_code": "bg",
      "roman": "surogáten ključ",
      "sense": "Translations",
      "tags": [
        "masculine"
      ],
      "word": "сурога́тен ключ"
    }
  ],
  "word": "surrogate key"
}

Download raw JSONL data for surrogate key meaning in English (1.5kB)


This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2026-06-15 from the enwiktionary dump dated 2026-06-01 using wiktextract (03da280 and 7f4db16). The data shown on this site has been post-processed and various details (e.g., extra categories) removed, some information disambiguated, and additional data merged from other sources. See the raw data download page for the unprocessed wiktextract data.

If you use this data in academic research, please cite Tatu Ylonen: Wiktextract: Wiktionary as Machine-Readable Structured Data, Proceedings of the 13th Conference on Language Resources and Evaluation (LREC), pp. 1317-1325, Marseille, 20-25 June 2022. Linking to the relevant page(s) under https://kaikki.org would also be greatly appreciated.